SyApplicationKey

EntityType | Independent
Logical Entity Name | SyApplicationKey
Default Table Name | SyApplicationKey
Logical Only | NO
Owner | dbo
Definition |
Note |

SyApplicationKey Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SyApplicationKeyId |  | CHAR(10) | NO |
ApplicationKey |  | CHAR(10) | YES |
CallingApplicationName |  | CHAR(10) | YES |
AssociatedStaffId |  | INTEGER | NO |
IsSystemGenerated |  | CHAR(10) | NO |
ExpirationDate |  | CHAR(10) | NO |
AddedByUserId |  | CHAR(10) | NO |
UserId |  | CHAR(10) | NO |
DateAdded |  | CHAR(10) | NO |
DateLstMod |  | CHAR(10) | NO |
ts |  | CHAR(10) | NO |

SyApplicationKey Keys

Key Name | Key Type | Keys
PK_SyApplicationKey_SyApplicationKeyId | PrimaryKey | SyApplicationKeyId
UK_SyApplicationKey_CallingApplicationName | Alternate Key | CallingApplicationName

SyApplicationKey Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | One To Zero or More |  |  |  | AssociatedStaffId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SyApplicationKey Check Constraints

Check Constraint Name | CheckConstraint

SyApplicationKey Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyApplicationKey | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyApplicationKey | NO |  |  |

SyApplicationKey Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model

SyApplicationKey Data Movement Rules

Name | Type | Rule Text/Value